﻿CREATE VIEW [dbo].[ASMS_V_Station]
	AS 
SELECT S.*,
	B.Name as BusinessName,
	B.ShortName as BusinessShortName
FROM ASMS_Station as S
	inner join ASMS_Business as B on B.Id = S.BusinessId
